let
    Source = Json.Document(Web.Contents("https://opendata.paris.fr/api/records/1.0/search/?dataset=velib-disponibilite-en-temps-reel&rows=1500&facet=overflowactivation&facet=creditcard&facet=kioskstate&facet=station_state")),
    records = Source[records],
    #"00001" = Table.FromList(records, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"00002" = Table.ExpandRecordColumn(#"00001", "Column1", {"fields"}, {"fields"}),
    #"00003" = Table.ExpandRecordColumn(#"00002", "fields", {"nbfreeedock", "nbebike", "station_state", "maxbikeoverflow", "station_type", "overflowactivation", "station_code", "densitylevel", "nbedock", "station_name", "nbdock", "station", "nbbikeoverflow", "nbfreedock", "nbbike", "overflow", "creditcard", "geo", "duedate", "kioskstate", "nbebikeoverflow"}, {"nbfreeedock", "nbebike", "station_state", "maxbikeoverflow", "station_type", "overflowactivation", "station_code", "densitylevel", "nbedock", "station_name", "nbdock", "station", "nbbikeoverflow", "nbfreedock", "nbbike", "overflow", "creditcard", "geo", "duedate", "kioskstate", "nbebikeoverflow"}),
    #"00004" = Table.RenameColumns(#"00003",{{"nbfreeedock", "Nombre de bornes disponibles"}, {"nbebike", "Nombre vlo lectrique"}, {"station_state", "Etat des stations"}, {"station_type", "Type de stations"}, {"overflowactivation", "PARK + activation"}, {"station_code", "Code de la station"}, {"nbedock", "Nombres de bornes en station"}, {"station_name", "Nom de la station"}, {"nbdock", "nbDock"}, {"station", "Description station"}, {"nbbikeoverflow", "Nombre vlo en PARK+"}, {"nbbike", "Nombre de vlo mcanique"}, {"overflow", "PARK +"}, {"creditcard", "Achat possible en station (CB)"}, {"kioskstate", "Etat du Totem"}}),
    #"00005" = Table.ReorderColumns(#"00004",{"Code de la station", "Nom de la station", "Etat des stations", "Etat du Totem", "Nombres de bornes en station", "Nombre de bornes disponibles", "Nombre de vlo mcanique", "Nombre vlo lectrique", "Achat possible en station (CB)", "PARK + activation", "Nombre vlo en PARK+", "maxbikeoverflow", "Type de stations", "densitylevel", "nbDock", "Description station", "nbfreedock", "PARK +", "geo", "duedate", "nbebikeoverflow"}),
    #"00006" = Table.RemoveColumns(#"00005",{"Description station", "densitylevel", "nbDock", "nbfreedock", "maxbikeoverflow", "Type de stations", "nbebikeoverflow"}),
    #"00007" = Table.TransformColumnTypes(#"00006",{{"Code de la station", Int64.Type}, {"Nom de la station", type text}, {"Etat des stations", type text}, {"Etat du Totem", type text}, {"Nombres de bornes en station", Int64.Type}, {"Nombre de bornes disponibles", Int64.Type}, {"Nombre de vlo mcanique", Int64.Type}, {"Nombre vlo lectrique", Int64.Type}, {"Achat possible en station (CB)", type text}, {"PARK + activation", type text}, {"Nombre vlo en PARK+", Int64.Type}, {"PARK +", type text}, {"geo", type any}, {"duedate", type date}}),
    #"00008" = Table.RemoveColumns(#"00007",{"PARK + activation", "Nombre vlo en PARK+", "PARK +"}),
    #"00009" = Table.RemoveColumns(#"00008",{"geo", "duedate"})
in
    #"00009"